home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
An Invitation to the Roland World of Music
/
Roland - An Invitation To The Roland World Of Music.bin
/
vb
/
vb30
/
disk2
/
btrieve.tx_
/
btrieve.bin
Wrap
Text File
|
1993-04-27
|
6KB
|
159 lines
------------------------------------------------
Visual Basic Version 3.0 Btrieve Information
April 16, 1993
------------------------------------------------
(C) Copyright Microsoft Corporation, 1993
This document provides supplementary information on configuring
Btrieve for use with Visual Basic. Before you import,
export, or attach Btrieve tables with Visual Basic, please
read this file.
--------
Contents
--------
General Considerations
Using Compressed Data Files
Using Btrieve in a Multiuser Environment
Setting Btrieve Options in WIN.INI
Configuring Novell Network LAN Manager (NLM)
----------------------
General Considerations
----------------------
When using Btrieve data with Visual Basic, keep the following
considerations in mind:
- Btrieve data files must be in version 5.1x format.
- You must have the data definition files FILE.DDF and FIELD.DDF,
which tell Visual Basic the structure of your tables. These
files are created by Xtrieve or another .DDF file-building
program.
- You must have the Btrieve for Windows dynamic-link library
WBTRCALL.DLL, which isn't provided with Visual Basic.
This file is available with Novell Btrieve for Windows, Novell
NetWare SQL, and some other products for Windows that use Btrieve.
- You can't use Btrieve files that have Xtrieve security. To use
data files with Visual Basic, disable Xtrieve security.
---------------------------
Using Compressed Data Files
---------------------------
If you're using compressed Btrieve files, you must be sure that
the compression buffer Btrieve is using is adequate for your data.
The buffer size must be at least as large as the largest record
in your data files.
To ensure proper operation, set the compression buffer size
option (/u) in the [btrieve] section of your WIN.INI file. The
units for this setting are kilobytes, so if your largest record
is 2K, you would add /u:2 to the Btrieve options line in WIN.INI.
For more information on setting options, see "Setting Btrieve
Options in WIN.INI" later in this file.
----------------------------------------
Using Btrieve in a Multiuser Environment
----------------------------------------
If you're using Btrieve in a multiuser environment, you must
use the same transaction file (BTRIEVE.TRN) as other users on
the network. To do this, set the transaction file name option
(/t) in the Btrieve section of your WIN.INI to point to the
network location of BTRIEVE.TRN.
For more information on setting options, see the next section
of this file.
----------------------------------
Setting Btrieve Options in WIN.INI
----------------------------------
When you install Visual Basic, Setup adds the following
section to the WIN.INI file in your Windows directory:
[btrieve]
options=/m:64 /p:4096 /b:16 /f:20 /l:40 /n:12 /t:C:\ACCESS\BTRIEVE.TRN
Although these are the recommended option settings, you can
change these options in your WIN.INI file using the following
table as a guide. If the option you want to set is not on
the line, add the option and desired setting at the end.
Option Description Required value
------ ----------- --------------
/m Memory size At least 38
/p Page size 4096
/b Pre-image buffer size 16
/f Open files At least 4
/l Multiple locks At least double the setting for
the Open Files option (/f)
/n Files in a transaction At least 4
/t Transaction file name Valid path to a .TRN file;
in a multiuser environment,
network path to the .TRN
file shared by all users
/u Compression buffer size If your Btrieve data files are
compressed, at least the length
(in kilobytes) of the longest
record in your data files
/i Pre-image file drive
/c Index compaction
/a Activate logging
/s Discard unneeded segments
--------------------------------------------
Configuring Novell Network LAN Manager (NLM)
--------------------------------------------
If you're using Novell Network LAN Manager (NLM), there are several
considerations you must keep in mind about your configuration.
Before you use Btrieve data with Visual Basic, you should
check for the following:
- You must have the following section in your WIN.INI file:
[BREQUESTDPMI]
datalength=4096
tasks=10
local=no
chkparms=no
- You must have transactions enabled on your NLM server.
- You must be using version 6.0 of the NLM requestor files--
BREQUEST.EXE, WBTRCALL.DLL, and WBTRVRES.DLL. (However, note
that you must still be using version 5.1x data file format.)
If you don't have the correct versions of these files, you won't
be able to use Btrieve with Visual Basic. If you have access
to Compuserve, you can download the necessary files for this
configuration using the instructions below. If you don't have a
Compuserve account, contact your Novell representative and ask
for the 6.0 versions of the requestor files.
To update your Btrieve NLM files from Compuserve:
1. Connect to Compuserve and GO NOVLIB.
2. Go into the Btrieve/XQL library section.
3. Download the file BT515.ZIP, and then unpack the file using PKUNZIP.EXE.
4. Unpack the file BTRREQ.ZIP (one of the files from BT515.ZIP).
5. Follow the instructions in the README file for installing the
resulting files and applying necessary patches to the
BTRIEVE.NLM file on your server.